package com.fz.mapper;

import com.fz.entity.Stu;
import com.fz.entity.Student;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

import java.util.List;

/**
 * Created by ZCY on 2018-01-19.
 */
public interface StudentMapper {
    /*使用配置的进行存储过程*/
    public List<Student> show();
    /*使用注解的形式进行操作存储过程*/
    @Select("call stshow")@Options(statementType=StatementType.CALLABLE)
    public List<Student> myshow();

    public  List<Stu> ssshow();
    /*数据库中存储过程进行传参数进行delete*/
    @Delete("{call did(#{id})}") @Options(statementType = StatementType.CALLABLE)
    public int delByid(int id);




}
